
import java.sql.*;

public class TableCreation {

    public TableCreation() {

        try {
        	DBManager db = null;
            Connection connection = db.openDBConnection();
            Statement st =  connection.createStatement();

            String table1  = "CREATE  TABLE `chain`.`registration` (  `EMPID`  VARCHAR(40) NOT NULL  ,  `NAME` VARCHAR(100) NULL ,   `VEHC_REG` VARCHAR(45) NULL ,  `PHONE_NO` VARCHAR(45) NULL ,  `GIFT` VARCHAR(45) NULL ,  `ADDRASS` VARCHAR(100) NULL  , PRIMARY KEY (`EMPID`) );";
            String table2  = "CREATE  TABLE `chain`.`agent` (  `EMPID`  VARCHAR(40) ,  `NAME` VARCHAR(100) NULL ,  `AGNTNAME` VARCHAR(100)  NULL );";
           
           
            st.executeUpdate(table1);
            st.executeUpdate(table2);
          
            connection.close();
        } catch (Exception e) {
           e.printStackTrace();
        }
    }

    public static void main(String[] args) {
        new TableCreation();
    }
}
